I need some urgent help with quarter field I have 3 columns in my database OrderNo, OrderData, OrderAmount say that the date right now is Jan 07 then I...

Hi I have two tables. Table 1 has say HHID 1 to 1000 (1000 rows) and different fields. Table 2 has only intermittent HHIDs say 456, 12, 23..and 100 such HHID...

I have a database where I am attempting to create a complex weekly report for employee production. I am struggling with the date portion of this project. The...

Hi, Hi I'm trying to do a countif function (although that does exist in access), but something else should be fairly simple... I'm in a 'Totals Query' where I...

I have two tables joined one to many. The one is patient name, the many is scan date. When I run my query it will give me the patient name as many times as...

I am attempting to combine 3 fields into one and not having much success. I've created a new field called GRANTALL in a query to accept this. All fields...

This is my curent query: SELECT User.PKey, User.UserId, User.Administrator, User.MedONLY, User.FilterCRT1, User.FilterCRT2, User.FilterCRT3, User.FilterCRT4,...

Is there any way to create a table name in a make table query that will include the date? I want to have a history of tables and would like to have the date as...

Hi I have three tables with a common id with which they can be linked. I need to merge them in a way that the resultant table has all records from three...

I am trying to run the following query SELECT qry_AllWrkLoggedDate.Date, tblAllWorkLoggedRecords.DEPARTMENT, Sum(tblAllWorkLoggedRecords.) AS FROM...

Francois wrote: Can I add several colums to a access table in a single ALTER TABLE statement ? I am using ODBC, but always get a syntax error. No,...

I would like to make a query on a table on one field to 'sum' or 'max' the field based on 'if' another field is null or not. Any idea on how I would go...

The Select query displays 1287 records. When I created this query without the Fiscal Month table, I got 1287 records. When I added the INNER JOIN with the...

I've got a query that selects dates based on if a date is null or not. IIf(IsNull(), IIf(IsNull(), IIf(IsNull(), IIf(IsNull(),(-14),), ), ),). This works...

hi, I have a table in which there are empty values for record in a specific column. I tried to do a find and replace, but to no avail. Is there a...

I was not able to run an update query or an append query. Please show me how to create one.

Ok, I have a picky boss who is asking me to make a query that will show all spending by payee and also show project spending in same query. Is this...

I have 3 yes or no fields, the first field is always a yes/Injury field and the 2nd/Lost Time and 3rd field/Medical can be yes or no depending on what action...

I have a football league table that works fine, but I don't know how to put a column with the position in the league, (1 - 12)

In short, if tbl2 have some value in it, retrieve only the matching records in tbl1 otherwise, if tbl2 is empty then retrieve all the records from tb1. This...