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

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