New to Access: Single query for multiple unrelated tables

[caringsharingbristolbilly]

Hello. I'm pretty up on my Excel knowledge, but have switched to Access recently for a database I'm working on. I now realise how much Excel 'nannies' you!

Anyway, my problem.

I have a database consisting of 8 data tables showing client data. The data items on the tables aren't related, but they do share 2 column headings and data types within those headings (one of which is Date, the other is Status). I want to do a report showing the Status Categories I've applied for clients over a certain date range, broken down by each of the 8 tables. As I want the user to be prompted for the Start Date and End Date, and I don't want them to be prompted 8 times, is there any way I can include all 8 tables in one query?

When I've tried, it keeps asking me to set up a relationship for the tables, but they aren't really related as they don't share client information. Or are they?

If you need any clarification at all, please ask.

As I'm feeling Access and I are getting off to a shaky start, any help would be gloriously received, and I will send a packet of cadbury's buttons via e-mail (rather a jpeg of some) to anyone who can help me out!!

Thanks in advance,
Bill Knibb

 

[caringsharingbristolbilly]

Re: New to Access: Single query for multiple unrelated table

It doesn't give me a pop up box when I press the button on frmopenreport, but it does when I double click the query or the report in the database view. When I click the button on frmopenreport, it goes straight to the (blank) report.

SELECT RufusAddressTable.Done_Or_Not_Done, Count(RufusAddressTable.Done_Or_Not_Done) AS CountOfDone_Or_Not_Done
FROM RufusAddressTable
WHERE (((RufusAddressTable.Last_Updated)>=[Forms]![frmOpenReport]![txtStartDate] And (RufusAddressTable.Last_Updated)<=[Forms]![frmOpenReport]![txtEndDate]))
GROUP BY RufusAddressTable.Done_Or_Not_Done;

Cheers again... Glad to know it's not just me going mad. Well, it might be, I suppose...

 

[bat17]

SQL looks OK to me. The only other suggestion at the moment is to format the textboxes as date just to make sure the Access is getting it right.

Peter

 

[caringsharingbristolbilly]

Re: New to Access: Single query for multiple unrelated table



Already done that. Oh well. If you wake up in the middle of the night with a solution, remember to write it down, eh?

Thanks again. I appreciate it.

 

[caringsharingbristolbilly]

Re: New to Access: Single query for multiple unrelated table



Okay. Well. Sorted now. I did say I was new to Access, right? I right clicked on the actual text boxes on the form and renamed the boxes that way. I rather foolishly thought that renaming the label boxes would feed through to the text boxes themselves. I feel rather embarassed now. Sorry to have been a pain!!!

Thank you so much for your patience...

 

[bat17]

Glad you got it sorted Access is fun... as long as you keep taking the tablets!