Search results

I have a table that has personnel names in one field, then in several fields are expiration dates for various licenses they hold. Can I construct a query that will let me enter in a certain month/year as a parameter and it would bring up all of the licenses which expire that month/year along...

I have this table. Field 1 is date. Field 2 is "Location X". Field 3 is "Location Y". Field 4 is "Location Z"...you get the picture, only I have about 10 locations to work with. When entering data into the table, in field 1 you put the date. Then into fields 2-4 (in this abreviated...

I want to print a total for a particular field on a report. I know what to put in the text box to do this, but I don't know how to place the text box. If I put it above the "Page Footer" in design view, it prints the total after each record. If I put it below the "Page Footer" line, it gives...

I'd be willing to put it on a report. I've already got one set up for the query. Can you tell me how to put a sum in the report? Bear with me...as you can tell, I'm just learning the basics. I really appreciate your help!

When I try doing [Enter locations] and I type in a location as it is listed in my lookup table, I get an error saying it is typed incorrectly or is too complex. All I'm entering is the code "san" or "bayou" as they are listed in my lookup table. Any other suggestions?

I have a query which gathers the cost/day of certain personnel at certain locations depending upon the parameters you set. What I would like to know is if I can put something in the query that would then total the column cost/day. Thanks for any help you can give.

Can I design a query that will give me totals in certain fields after the query is run?

I'm designing a query. I want to include the field "Location". "Location" in the table I'm quering (is that a word???) is a look-up field, so that my people can just click on their choice from a list of locations. I want to have a parameter in the query so that they can specify which location...