Recent content by waredata

Access 2007 - I have a text box for [ExpDate] , input format is 0\4/\10;0; formatted as mm/yyyy. Question is I need to know if the date entered is less than current month to be highlighted. Conditional Formatting: Condition 1; "Field Value Is", less than, What do i put in the next box? <...

I have three select query that I would like to run together. I know the fields has to be the same. (They are) I know: SELECT field1,field2, etc FROM [Name of query] UNION SELECT field1,field2, etc FROM [Name of query]; How do i add the third query?? Do I just repeat the above, for one more...

:confused:I have a report that does about 200 Invoices.:confused: Problems I have, that I need to print is: Invoice has beg amt (No add'l charges or payment) Invoice total should only show the beg amt as the INVOICE total. How can I get this report to PRINT this invoice? (Have several) How...

Please see if you can help me out.

I am not that much of a newbe, I have been working with database since db1, I'm just a user/basic.. Never had a chance to learn programming such as VBA. Thanks, anyway

Basically I have two major tables: Customers info & data I'm trying to create statements base on the data per month. Statement would have Beg Total (prior month ending total), current month charges - payments + taxes = Ending Total I use a ([BegDate]And[EndDate] on [Date Posted])to show...

:confused:This is trhe first run on Access. They were done on a ASA400 format last month. Thats why I added the balances from last month, into this one.

yes it does.. It needs to run a statement if only they have a begining balance and a ending balance. What I see are only those that has charges during the month I'm asking for.

Database consit of Customers with Charges + payments I'm trying to create statements on these customers. Base on Between dates Such as BegDate:03/1/11 EndDate 03/31/11 Should show a statement for every customer that has a balance. But it don't. Statement: BegBal (1 day before BegDate for...