Search results

Allow me to elaborate. It's the FeeType I would like to tally. When users type in a FeeType along with a FeeAmount (any value), it's possible to have several of the same FeeTypes for the month. So, if a user has four "X" transactions for $100.00/ea and two "Y" transactions for $10.00/ea...

vbaInet, Let me elaborate a bit more. Currently on my form (Switchboard), on load I have: Private Sub Form_Load() DoCmd.Maximize End Sub Shall I include the calendar code within the "Private Sub Form_Load() procedure?

Access 2003. How can I get a calendar that displays the current date when the form is opened?

Access 2003. I have a form allowing users to enter a: FeeType and a FeeAmount. I also have a report (based on this form) calulating just the FeeAmounts. The FeeTypes consist of six choices. The user chooses one of the six. Along with their choice is the appropriate FeeAmount. I want to...

Alright Galaxiom...I was trying to avoid you, but I guess I need to face the music. The 60+ fields I have on the main table/form is used to record specific data that may or may not occur for a single event. For each event there may be any of those fields utilized to collect a statistic. Once...

jdraw, Excellent turtorials, however most of my data is numeric. I would like a parameter query that would enable me to select any specific field for any specific date range and retrieve that specific number (stat) from the field of my choice. Any suggestions?

Big Booty, Can you elaborate on the "various combo boxes" and "text fields?" Also, would I be able to use this form to extract any specific data for any specific day, on any specific field?

Big Booty, Can you elaborate on the "various combo boxes" and "text fields?" Also, how would I be able to use this form to extract any specific data on any specific day for any specific field?

You're right! Sorry Dave. You did put me on the right track. You guys are great!!!

Got it! It worked! Thanks Bob!!!

Alright, let me back up a bit here. I have a "Date" and "Time" field (separate fields). Some data is entered more than once on the same day. I want to sort both the date and time in my report based on my query.

My report is based on the query I have set for ascending order.

I don't see a sort order in the field's property.

Access 2003. Why isn't the "Time" field sorting in ascending order just like the date. It sorts ascending in query, but not in report?

Access 2003. I have a table with 60+ fields. I also have numerous queries/reports for specific data. Instead of having a specifc query/report for specifc data, I would like to create a "parameter" query/report that can randomly pull any data I want from my table. HELP!

The query worked! Thanks Linq!!!

Access 2003. I've got a table along with it's associated form. Users began inputting data on 11-18-10. We've had consecutive data for over a month now. We are now having to go back and input data from 10-1-10 thru 11-17-10. This This will enable users to retrieve data from day one of fiscal...

Yo Bob! This is my dilemma. Our users inputting these figures CAN'T ADD, so I'm trying to automate this field for them. I already have various queries/reports that have calculations in place. It's my main table/form that the data is entered in manually. I have to rely on the users adding...

Access 2003. I've got a form based on a related table. I converted a field on the form to now begin calculating figures automatically from four separate fields. (I created this after the fact). The calculation of those figures adds up, however the total is not being displayed on the table...

I like it. I'll try it. Thanks lagbolt! I'll get back with you.