ah i see sorry it is too early in the morn try SELECT DISTINCT latestgpsrecord.Individual_ID, latestgpsrecord.MaxOfdate,...

Oops, one more complication that I hadn't forseen. In my first query I only needed the date of the last locate... but if I want the location (lat/long), then...

I have a query set up to use the date parameter entered into a form. I would like the query to be limited to the date or before that is entered on the form....

I have a date field that is entered by user and a date field that needs to calculate a future date (3 mths or 12 mths) based on input from user from a drop...

Hi All, I have a field in query design that checks for If...Elseif...Else. Below is the field. I am having the issue with the field. I get syntax error. ...

.... why dont you just add them to your normal query i see no reason to use a sub query SELECT...

We currently use an Access database to monitor project expenditure in particular sections. I would like to be able to automatically generate a change in...

I have two related tables Expense reports expense details with one linking key ExpenseReportid suppose i want to delete one record from the first table ,...

I have a table called simpleweather with a date field, showing 20/10/2008 19:32:00 DD,MM,YteY hh,mm called datadate, outdoors (which is a temperature...

I have a table called simpleweather, and the 2 fields I am interested in are datadate which is the date in the format dd,mm,yy hh.mm outdoors which records...

I need to build a duplicate query based on two different criterias. It needs to have one record for "D1" and one for "HSIF" to be considered a duplicate. ...

I currently have two tables: #1: tblBirthInformation #2: tblPurchase/Donations As animals die or are sold or transferred they recieve a disposition number...

Table example: Last First Read-1 Lang-1 Read -2 Lang-2 Doe Jane 89 90 88 ...

Hello John, Please see my post initiated 10/15. You requested my SQL and the error message to my IIf problem and I've posted them. Please review and let...

I need help. How do I make my database open to a my switchboard and not show, my reports, queries, or tables.

Hi, I am new to Access, so forgive my ignorance. I'm trying to do two separate things. In my Criteria cell, I set an IIF expression like so,...

I have been fighting with this most of the day and can't seem to spot why this will not work: SELECT tblProjInfo.Period AS ConstPrd, Format(,"mmm-yy") AS...

I have an expression in a query to calculate the time difference (in decimal hrs) the length of time between arrival and departure time. this works fine and...

Hi, I have small problem in performing running total. My data table something like union all loan disbursal and perioical repayments which indicates...

Hi everyone, I've got a problem with an SQL query. The column name I'm asking for has parentheses inside its name. . The query is: select from It shows an...