I'm beginning to question my own sanity here. I have a simple query that derives these fields: UID Firstname Lastname Registered Updated Accessed Num The...

hi again - i wud want the user to enter the employee code. That ecode would be checked in the table for a duplication and based on the result, if the ecode...

Hello, I have a query that has a date/time field on it and in the criteria field i have Date()-1. My problem is that on Sunday there is no data... so what I...

I've got a field with several 100 characters. The exact composition of those characters vary. However, in all records, a certain exact phrase will always be...

Hello experts in Access! I'v got some problem with a query. In this query there are several connected tables. When I run a query I get empty lists. For...

Hi All, I am having a little bit of trouble with a query of mine relating to training courses. This query is supposed to look at the last date a person took...

Hi, I think there's a bug in an ODBC driver (Advantage ODBC 9.0.0.1). Here's the SQL: SELECT TRDATA.ACCT, repolog.Acct, TRDATA.STATUS FROM TRDATA LEFT JOIN...

I am having an interesting problem with mail merge. I have a query which will not show up on the mail merge window. I see other tables and queries but not...

Hello, I have a table like this: tblEACodes: ============================== SK AQ_FKEY aqeEA_FKEY == ======= ==== 10 26 6 21 ...

Hello Access experts! I have a question is it possible to make more text fields in a query? I have a query that needs to take out a lot of info from connected...

There’s a table, with the format: Table1:price,with only one column. I want to use query to Make it output as follows: 1. Price in (0,50k) Price in...

I am having trouble constructing an Update query using Lpad. I keep getting an "unidentified function 'Lpad'" error message. The same happens in Query.

Hello NG, is there something like SUM, but for strings? I can do SELECT SUM(colname) FROM mytable WHERE whatever GROUP BY whatever;

Hi.. i want to find a number (employee code) and if that exists in the table (employee master), then retrieve the rest of the details of that record and...

I have downloads from the bank including check numbers containing leading zeros. eg 0002356, where what I want is just 2356. How do I enter formatting in...

I have a table 1, information of customer, primary key custID; Table 2 , information of accounts, primary key account number, one account number is under one...

I seem to have developed a talent for breaking Access. I have a table of user data with near-duplicate rows. I want to pull out the most recent account for...

I'd like to have an EXISTS clause in and ORDER BY Clause, but I keep getting a syntax error, even though it looks clean. Here it is: ORDER BY Exists (SELECT...

I would like the query to display product under warranty for 90 days from the repair date(s) and display product that have expired past the 90 day warranty...

I have to retrieve a list of people whose passports have expired. I have the list in the access database. Im trying to write a query to filter out those ppl...