Hi, I doing a calculation in a query of the difference in times. I'm wondering if I can control the decimal precision to be just (2) places. The number I end...

Hi guys. I'm using Access 97 (SP2) to do some work for a client. I am running a Union Query on two tables tht are identical, to create one set of data. Here...

Hello I have two Tables. tblMain(MainID) tblSec(FamID, Group, MainID) MainID has same attribute in both tables tblMain has the correct records. How can I...

I have 2 queries that I am building another query off of. I have on query with the name of project contacts in it. I have another query with all the...

Hello Access 2003. I have a query with the following parameters. Like !. & "*" ‘Data are in TAA Like !. & "*" ‘Data are in TBB Like !. & "*" ‘ Data are...

I have a query that calculates records between two dates as Between And Is there a way to show a default value for the beginning and ending dates in the...

I get an error message with the following sql statement. It does not seem to like the format "short date". Could someone check the syntax for me and see where...

I have a table that contains the following information: Auto ID, PersonName, EventName, EventDate PersonName, EventName, and EventDate are not unique. There...

Hello I've been struggling with this all day, and although I think I'm near a solution (actually I thought that 2 hours ago!) it now involves 4 nested queries...

Hi, I'm fairly new to Access, and I need to write a query which will check a memo field to see if it is null, then display "n" (for not having data in the...

You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or the reverse if Table2 always has a date. -- Build a little, test a...

Hi, I have some 20,000 entires populating a text filed that ideally should be a combo box. I'm looking for the best way forwards with this and wonder if...

Hi, I have a few tables and want to run a query, but am not sure how the sql will work out. I have a table that has a list of students, and a results table...

Hi David, Rather than running an export for Access to Excel, and then getting others to sum columns, try this single query that should do what you...

i have a table, tblgeneral, that contains order information on customers, referenced by tblcustomer, what i am attempting to do is show how many unique...

We have a query that has been working quite happily for over ayear, but has suddenly decided to play up, giving a "No current record" message box. The query...

Apologies for repeating what has probably been asked before although my newsreader can't find anything! I'd appreciate any advice on Access books and...

I have a report that generates assignment sheets for exhibitors who have received booth assignments so that the orders can be updated (for various reasons,...

I have a database that tracks items and who they belong to for work. The person and everything they have been given are entered into a form which updates the...

hello all i am attempting to create a parameter query, which is where you would put in the "criteria" section in order to have access prompt you with a text...