Search results

I need to pull the records that are between two dates I specify [Dates Received] or have a Balance. But I don't want to pull the records that have a balance but aren't between the two dates I specify. Here are some of the fields Name Amount Received Date Received Balance. I currently have...

I have a report based on a parameter query that pulls records Between #date# And #date#. One field, [Margin%] is a complet calculated field. On the report I have, example: [Margin%] [Comm%] [Rcvd$] I insert a calculated field, [NewField], that does the...

I created a parameter query which works but . . some of the fields in the query are calculated fields and these fields are "popping" up along with the parameter field I set up. The correct parameter field is the only one with the "WHERE" in it. I just hit enter when these other fields "pop"...

I have a report set up through a parameter query. I would like the user input data from the parameter to be included in the heading of the report. Is this feasable?

I have a database that I need to house data per employee per month. I have base records which represent January. One field holds the month, ie 01/02. I wish to copy and past all these records, but change the month field on the new records to 02/02. In future months I will need to specify to...

How would I create a macro that would allow user input for a criteria into field in a query?

I have been unable to get Access to accept my nested If statement in a query. I have recently begun using Access2000. Is there something new with this version? This is the statment that is currently not being accepted. Expr1: IF([tbl Emp types_ID]="W2S",([DyPay]*1.18),IF([tbl Emp...