PercyPercy
Last Activity: Jun 30 '06, 05:44 PM
Joined: Jun 28 '06
Location:
-
You can certainly use me -- though I still consider myself a novice -- especially when it comes to writing expressions. But I'll be happy to share what I can!... -
That's what all that Y-2-K thing was about. Unfortunately, without seeing all your tables and data, the thing I would do (probably not the right thing to do, but it would work):
To the table that contains your "06###" field, add another field to hold the 4-digit year associated with it.
THEN add that field to the query your report is based on.
THEN, in your report, sort by the year field FIRST,...Leave a comment:
-
Yeah -- I hate that reading thing too. I usually struggle on my own... then pick-up the manual and wow -- there it is! *S*
Actually, that parameter is in the query the a form or report is based on. The form or report is located on the Switchboard. When they clock on the form or report they want to open -- they get prompted with the little input window....Leave a comment:
-
Gary,
Are you using a "switchboar d?" If you are, there is already a feature for the "quit" or "exit" already built in. Assuming you are using a switchboard, try this:
1) Under the TOOLS menu, go to DATA BASE UTILITIES, and select SWITCHBOARD MANAGER
2) The Switchboard Manager window will open. Select the Switchboard that you want to contain your quit/exit button,...Last edited by PercyPercy; Jun 29 '06, 03:43 PM.Leave a comment:
-
Banfa,
Thanks for your prompt reply. Unfortunately, I'm such a novice that I'm still a bit lost. How would this actually be entered in the query? I'm assuming I would have four columns in the query:
transaction id_______produc t number_______tr ansaction qty________expr ession
Then I would use the SUM feature so the "group by" row appears.
Then I would build the expression above in...Leave a comment:
-
Getting a Total from a Single Table in Access
For some reason I can't write the proper query to get a simple total from a single table. Here is the basic table design:
Transaction ID___Product ID___ Transaction Date____Transac tion Quantity
1______________ Product A____6/12/2006__________2 00
2______________ Product B____6/12/2006__________5 00
3______________ Product C____6/14/2006__________1 00
4______________ Product B____6/15/2006__________2 00
5______________ Product...
No activity results to display
Leave a comment: