I have a query that calculates various costs. There's one field that has 3 possible values, and depending on what it is the value (cost) can be shown in...

How do i get into an already created Update Query in order to edit it?

I have the following table setup Table Name - tblInventoryCounts Field Names - Store Number, Count Date, Item name, Count Amount Sample Data Store Number ...

Would appreciate some help as I'm a novice Access user. I have a table with employee numbers. The majority are 7 characters (text) that start with a letter...

Is it possible to create a query that divides the results of one query by the results of another query? If so...how? Thank you to all for any help you can...

Using Access 2003, It is easy for me to a distinct Left join: Table 1 ID has 157 unique ID records. table 2 has 249 records some duplicate records in order...

How do I update the "Hire Date" date value to the current year or the next year if the "Hire Date" is less then 365 days old to be shown as an evaluation due...

hi there! I'm a bit stressed trying to get this sorted by I just cant! My question is the following. I have a database of three tables: Dis_cat, admission...

HI there, I need to query a product_code which is a text column. I want all results whe The first 'letter' is a 6. The second letter must be a letter (not...

Why does it take SO LONG TIME to open a query in design mode? I can understand that it takes a long time to run a query that returns millions of records. But...

I recently ran a query based on the date field. Ever since then, some of the dates in the field show up as ###### instead of the date I originally entered. ...

I have a query that asks for a start date and end date as parameters. Each time I run this query I have to enter the start date and the end date 4 times...

I deleted tables that had relationships to my master query. Now i can only see the master in SQL which I have no experience in. I've tried other means,...

Using Access 2007. I have a table of clubs and a table of club_gifts. They are linked via a key club#. I want to produce a report of all clubs from the...

So I have created my functions to calculate the expected deduction per deduction per agent number per account number. The problem I am having now is that I...

Access 2000 through 2007. How can I escape the ampersand used in query criteria? If I type a & b as criteria in a query, Access changes it to "a" & "b". The...

I have a small DB that keeps track of community events, where people can enroll and attend various courses. Each course is entered into the DB as well as...

Hi, I have a table where I have lists of colleges that my students have applied to as well as their status. The table has fields for student ID (foreign key...

I'm trying to get the query to check if an anniversary date is within the next 30 days, so I tried using this formula, but it did not work. Your help is...

I'm using Office 2007 - Access. I rename a working query. I run the query but it asks for a paramater which has the old name it. For example: ...