I have a table that was extracted from an ERP. The date was recorded in this table with a 1 in front of the date because they were unable to record values...

I want to nest iif statements to check if 3 conditions are as follows: Field one is null Field two is not null Field three is not null If the condition is...

Hi All, I've been searching the groups for help on my outer join syntax. So far, I get the hints that I should be using parenthesis. It helped for 3 tables....

I have a query which contains an IIF statement that checks for a value in a combo box in a form. It checks to see if it is null. If it is, then the query...

Trying to use a make table query. Would like to use starting date in the form, then increment by 1, 2 ect..to get Monday-Sat dates. Get "Data type mismatch...

I am working with a database that has many columns with the same data type. I need to compile this data into a single column - replicating the data in the...

I had to reformat dates in some queries from 1/2008 to 01/2008. Since I did this my append queries return error messages that say "The INSERT INTO statement...

I have a bunch of union queries in my Access database in which I've written the following type of SQL code: SELECT FROM WHERE =True UNION SELECT FROM...

I am looking to avoid having to use a bunch of nested IIf statements in the query I am trying to design. Is there a way to somehow create a table to which a...

I have a table that has the user select a Division from a drop-down (items are done through lookup to a Divisions table). I would like the next field to let...

I have a table with two fields; A_Date and A_Value. I need to create a query for this table showing daily variation. So, on day 10, for example, I will have...

I always need change to SQL mode create distinct queries. I just wonder is it possible to create disctinct query in design mode that I do not need switch to...

Here is my dilemma: I have a query with the following fields: AntibioticID (primary key) ICUAdmit (foreign key) OrderNumber AntibioticName Date

We have two tables, Meter Inventory and Location Table. We want to produce a listing of meters based on a group number within the inventory table. This is...

Greetings, I want to say up front that I'm NOT much more than a neophyte at Access. If I ask a "stupid" question here, it's because I really don't know that...

I posted this yesterday, but it doesn't appear to have gone through. Trying again. Hi all, I wonder if someone could help me tell me what I need to put in my...

Hi, I'm trying to get around not being able to export a report to Excel in Access 2007. So... I have a form (frm_Reports). On that form I have a number of...

I want to calculate time intervals between 2 dates - today and a user-specified date in the past. I fiddled around & came up with the following...

Hello all, I'm working on a transport-booking system for our Company. Previously we only used excel, unaware of the power we already had in our Computers...

I created a union query which returns dates (into a field called STATEDATE) like 5/19/07 6/23/08 4/3/07 etc. But the dates returned are in Text format (When...