simple question

[mystery45]

I am trying to build a report from my database.

The people that will be wanting this report will be wanting to view specific days of processing. Everything is keyed to the primary key which is called the CDC date.

I am not sure how to get access to allow someone to enter multiple CDC dates and then put then put those records into a report.

I have a report created however it lists all the records in the database which i need to be able to select X records at a time.

 

[Uncle Gizmo]

Your report will be based on a set of records either returned from a table or query. Create a new query based on this set of records, enter the criteria you want and you will end up with a set of records that meet that criteria . Now use this query as the record source for your report.

 

[mystery45]

Update ok i just got it so that I could get 1 report. now i need to get it so that i can get multiple records into 1 report.

also does docmd.openreport only work on strings or can you use numbers?

 

[Uncle Gizmo]

>>>now i need to get it so that i can get multiple records into 1 report.<<<

You will need to identify the criteria, (what identifies those records as the ones you want to see) and more importantly this criteria has to be something you can specify in your query. This could be a range of dates, from/to, things like that.

 

[mystery45]

thanks for all your help.

I made the query and added the

[CDC Date] with an integer parameter which is what it is to the criteria field.

If Me.CDC_Date = 0 Then Exit Sub
If Me.Dirty Then Me.Dirty = False
DoCmd.OpenReport "Game_Report", acViewPreview, , "CDC_Date = " & Me.CDC_Date

this is the code that I have. However it only pulls up the current record.

It will not pull up another record even though they are saved. It just comes up blank. This is exactly what I am wanting however I need it to be able to search for any specific CDC Date not just the current one.

not sure what is going on. (Again I know why I got out of programming.)