Search results

Can you give me an example of how to go about coding it? I'm very inexperienced with coding.

I've searched the forums for quite a while now and haven't exactly found the answer I'm looking for, so I appologize if it's already been covered elsewhere. I have a tough situation to explain, but I'll do my best: I have a query that has several fields that are calculated by adding or...

The parameters are entered when you open the report - you're prompted.

Just one graph based on all the records from a multiple parameter query.

didn't work, maybe I'm typing it in wrong. I tried it a number of ways: varX = DLookup("[Begin]", "[Cycle Time]", "[TEST_REQUEST_NUMBER] = ") varX = DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ") = DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ") =...

I'll see if I can explain my main problem here, then you guys (and gals) can see if you can shed some light on this... FYI- I'm running Access 97, most of my tables are linked to an ODBC database... The only way I'm able to display anything from a query (including parameters) on reports or...

I need to show a begin date and end date on a chart. I've tried every other "normal" method already without any luck - tried putting it on a form and referencing the form, other reports, and other round-about ways... If I could get rid of the blank pages this way would actually work. Is there...

I need the data source to stay though because I need to show a parameter from that report. I need a way to just get rid of all of those blank pages, but still have the report based on a query.

Took it out and still no luck... I checked the code too, nothing there except: Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) End Sub :confused:

I'm trying to be sneaky and get around another issue I have with a report, but I'm having some trouble. I need to create a report based on a query (no problem), but I need that report to show no fields. So, I go ahead and put the mandatory one field in from the report wizard, and from the...

bump bump bump

Thanks guys!

When is it appropriate to use a bang (!) verses a dot (.) when directing objects (like text boxes) to fields (like a parameter). i.e. =Forms![form name].field Thanks,

Has anyone had trouble converting from 97 to 2000? Specifically, converting current 97 databases to 2000. And, can others with 97 see databases from 2000? Thanks,

The dates are from Query #2. See Query #1 takes data from both #2 and #3. #2 and #3 take data from linked tables. In the criteria section of a date field in Query#2 I put in the following expression : Between [Beginning Date] And [Ending Date] Which works great for narrowing down the...

I'm tryin to have my Beginning Date and Ending Date parameters show up in a report. The report is based on a query (call it query #1). Query#1 is based on two queries (#2 and #3). The parameters stem from Query #2, which inturn proceeds to #1 and to the report. How do I show these dates on...

THANKS! I appreciate the help! :D

That's part of the problem, how do I reference them? -- What's the style for referencing something like that? I tried the period thing (Query Name.[Beginning Date]) like I said, but I'm not really sure how to reference a field of a particular query. Thanks for replying!

I want to put two text boxes at the footer of a report that display beginning and ending dates that were entered as parameters (like To: and From: ). But, the report contains a couple charts from completely different queries and the beginning and ending dates apply only to one chart. What do...

I'm trying to put a number of charts in one report. Each of the charts is from a different query, and each query requires a beginning date and end date parameter input. I do want to use the same date for every chart though. How can I do this??? I'm guessing I might be able to make each chart...