Crowbar
05-08-2008, 07:48 AM
I am scratching my head hard over this one....
I have inventory DB for 2 companies under 1 roof.
What I did was get the DB working for main company, make a copy, change some text on reports and forms from company A to company B.
now I am adding some new reports to both DBs - using a parameter query.
you know, the standard: Between [enter starting date] and [enter ending date]
this query works fine in both DBs
Now I use this query to make a report, and pass the parameters into the report by using the [enter starting date] as the control source in a text box.
This works fine for company A but I can't get it to work for company B.
I am sure the text matches exactly between the query and report, in fact I even tried copying the text and pasting it into the control source box.
I have tried copying the entire query and report from A to B, and tried writing everything from scratch, but the dates just won't show up. (comes up blank)
I am totally stumped, anyone ever have an issue like this?
I am sure its something dumb, but I just can't find it!!
I have inventory DB for 2 companies under 1 roof.
What I did was get the DB working for main company, make a copy, change some text on reports and forms from company A to company B.
now I am adding some new reports to both DBs - using a parameter query.
you know, the standard: Between [enter starting date] and [enter ending date]
this query works fine in both DBs
Now I use this query to make a report, and pass the parameters into the report by using the [enter starting date] as the control source in a text box.
This works fine for company A but I can't get it to work for company B.
I am sure the text matches exactly between the query and report, in fact I even tried copying the text and pasting it into the control source box.
I have tried copying the entire query and report from A to B, and tried writing everything from scratch, but the dates just won't show up. (comes up blank)
I am totally stumped, anyone ever have an issue like this?
I am sure its something dumb, but I just can't find it!!