Just converted to Access2003. All new queries created by either dragging individual column names from tables or double clicking table name and dragging all...

Hello, I have a query with a bunch of dates. I just want to drop the year off of the dates. I didn't find anything in the formatting options, and the...

I have a database w/ vehicles and thier info listed. In my query, I have a field that will be blank if the vehicle is available and when it is issued the...

I have a table that contains gender and age. I need to write a query that would give me counts for Males ages 30-50, Females ages 30-50, Males ages 51-60 and...

there are over 10,000 data in the table named z003. I tried to work out the flollowing calculation *+. All data in these three fields are in numuric format....

Can someone explain how to use the dmax in the query grid criteria line? I'm interested in getting the max date for an employee, where the employee id matches...

Hi there, This is my first post so be gentle. I need to run a query a number of times ( exporting the results to excel via transferspreadsheet ) each time...

I'm having trouble figuring out what to put in the criteria in my query to pull the correct info for my report. My report is grouped by month. I would like to...

I have the following string as the control source in an unbound text box in my Access report - at the end of the string, I want to put a currency formatted...

Hi. I'm trying to create a query that returns the Contact field twice, if applicatble- once as the original contact and once as the "ITA" contact. So a...

I wanted to know if you can use the datepart function in a query to extract a date such as 08/01/2005 from a date/time field such as 08/01/2005 10:55 . I have...

I want to make a query that counts the number of orders I have in my database from each company. I know how to add all of the monetary values of those orders...

Can anyone help office is autamatically locking all my documents can't even start a new word doc as it says its locked..

My response was not SQL code but it was criteria for your query date field. I will break it down. Date()-Day(Date()) is the current system date from your...

This may be a very simple answer but i just cannot figure it out. I have a query with multiple columns one being address. How could i search for only...

Can anyone advise how I can change the name of a field when I create an export file. I have a table who's data is exported orderID qty dacolID userID

Hi! I know VBA and SQL, but I'm new in Access. I would like to do a dynamic query, but don't know how, so if anybody could help me I appreciate it. What I...

I have a backend mdb and a frontend mdb. I have added a field to a table in the backend using code. Now I need to update a query in the front end that feeds a...

Hallo I hope some one can help me I have a query that has this as the criteria in the Date field: =#12/05/2000# And =#09/05/2001# This database now has...

How do I create a query to show when records do NOT match? My data is something like this. TABLE 1 TABLE 2 item number item number A 1...