Adding an autonumber id to a query 1

[KenCunningham]

Good afternoon,

hopefully a simple one, but it's beem some time since I had to deal with Access. We have a query qryQualitycheck which takes it's data from table tblQualitychecks. The latter doesn't contain a column 'ID', but the former (query) does. This app was created by a consultant - can anyone explain where/how the ID column appears in the field list of the query but not in the design view of the table itself.

As I say, it's been some time...many thanks.

I want to be good, is that not enough?

 

[lespaul]

what's the SQL of the query? There are ways to include a field in a query that looks like an autonumber...

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[KenCunningham]

Thanks, Leslie,

the sql is:

SELECT tblQualityChecks.*, IIf(Weekday(tblQualityChecks.Date_checked)=2,tblQualityChecks.Date_checked-3,tblQualityChecks.Date_checked-1) AS ClaimDate, Format(tblQualityChecks.Date_checked,"ww") AS [Week Checked]
FROM tblQualityChecks;

Anything obvious there?

I want to be good, is that not enough?

 

[lespaul]

Nope, nothing in the query!

I would then look for any settings that are hiding fields...I don't have Access installed on this PC so I can't dig deeper...but I know you can have "hidden fields".

I'm sure someone else will be along shortly!

Les

 

[KenCunningham]

Thanks - Les, I'll dig around a bit more myself!!

I want to be good, is that not enough?

 

[KenCunningham]

Les - a star for your intuition! Thanks.

I want to be good, is that not enough?

 

[lespaul]

I guess you found something marking the field as hidden?

Glad to help...I've been sick since Weds which is why I didn't respond sooner! Thanks for the star!

Les