Search results for query: *

I am in the process of creating a new database. Somehow, the menu bar has gotten away from me. It changes as I go from one form or table to another. There are only a few thing I really want on the menu bar, but even when I go to the tools options and set it up, I end up with more then I want...

I want to run a query with the results based on a value in a table not part of the query. The table has only one record called MINIMUM What is the format for such a critera, I have tried variations on the following: =table!TableName!FieldName But no matter how I write it, when I run the...

I have one query (called QryVMLimits ) where I allow the user to set a value called [minimum] I have another query where I want to list only those items that equal to or exceed the [minimum]as found in the first query In the criteria section of the field that holds the quanity I have...

I have a customer list that includes phone numbers. I am not allowed to change the customer table. The phone numbers are entered one number after another ( 18005551212 ). The numbers are a mixture of seven digits ( 555-1212) and ten digits ( 1-800-555-1212 ) When I do a report, I would like...

I have a table called work orders. It goes back to 1999. I build (using the Access query wizard) a cross tab query. I have one field that defines type of work, A=amc S=service. I want to count the number of each per month. I first created a query based on the table so that minium information...

I have several tables. The key field that links these tables is called device_id. When I use dlookup in a report I run into a problem. If I want to display an extension number from table devices I enter a dlookup statement that looks like this...