Recent content by Tuili63

Sorry for all the confusion. Guess that's due to the haze after a 3 day weekend. After rereading the posts I guess there is contradictions. Let me see if I can make myself clearer. These are the results I need: 1. Records within the dates received criteria. 2. Records with balances...

Rich, Unfortunately, the balance field is relevant. I do need those records to show as well. Reason: The query pulls money received during specific dates. These monies are calculated out for commissions earned. I also need to show the unpaid balances on the other records in the...

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"...

Thank you, it works great

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 figured it out.

David, I do need to keep a record per month per "consultant". This is to track each months' invoice amount and also for what was received and when. In the past I just copied, pasted and then retyped in myself. I run parameter queries to only grap the records that I need at any...

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 figured it out. Thank you

thank you. I tried it and it accepted it. But when I run it I get #Error in that field. Any suggestions?

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...