I keep getting enter parameter value for all the mods.whatever I tried
to enter a FROM paymenthist, mods but then I got a different error
UPDATE paymenthist2
SET paymenthist2.transdt = mods.dt

I have an append query that worked great pulling in data we are converting
from another source.  As the fields in our database increased, I split it
into some linked tables.  Now when I run the append query, I get key
violations because of the PK fields to the linked tables.

Is there a way to set global variables in an Access database and use those
variables in queries, without having thoes variables reside in a table or
query being used ...
Example.. i have a rate that is used multiple times in the same query, and

I need to be able to copy a record and then paste most of it as a new record
using a form.

I need to be able to copy my current record and then paste most of it as a
new record,
I don't want to duplicate all fields, I just want to duplicate some fields
and put different data in some fields (like in the date column I want to put

I am trying to write a query in Transact-SQL to create a user view in my SQL
database. I am trying to populate columns for each "aging" category (30, 60,
90, etc), so the correct age receives the amount due, but other columns are
zero. However, I can't find the correct CASE or IF ...

Hi, i need to know how to code a button to add a field from alot of
records and then put the answer in a textbox on a form asap please.
Thanks for any help you can give in advance

when i type a letter it dosent work another letter comes up. the pound sign
does not work instead this comes up #please help

I am searching through the discussion for a while now, but could not find
the answer to my question:
I have a aggregate query on a table - summing up some field with numbers.
The format of the field in the source table is set to standard, so when I run

I would be grateful if someone could tell me how to handle errors in
queries. The problem is that I am using DateAdd function to add up a number
to the date so for eg:
DateCleared = 12/01/2004

I have a simple query that prompts for input using criteria [Enter ID]. The
results of this query are as expected.  Now I want to filter these results
using a filter. When the filter is applied Access prompts for the input again
the same as when the query is first opened rather ...

I have a (fairly) complicated query that I'm piecing together. There's
just one part of it that I can't seem to get my head around - maybe it's
not possible.
Here's an example I've made up to simplify my question (rather than

i have a small doubt
I have a database where i have the fields as Name, DOB, Sex, Status,
Husbands/wife/Father's name, no of children, etc
While entering the datas for the above fields in the form, if the status is

This is on eof the most frusting problems.
I have tried to recreate the microsoft solution however it does not seem to
work. I have two tables. One with brand, year and value of sales. I would
like top 10 values per brand per year. Can anyone advise the query setup and

I am trying to create a query that will run a date range for an entire month.
To make it easier for users I want them to be able to just enter the # of the
month. For example, If they were to run a report for 09/01/05 to 09/30/05 all
they would need to do is enter "9" for the ...