Search results for query: *

I want to take the time to thank all who responded and helped me here.... I appreciate your knowledge, the willingness to share, and your helpful spirt... Houston... We have lift off!!!! Skylar Highe

I have tried that and it might be working but it still is telling me that it cant find a field. Unfortunately it doesn't list the field name it just lists a pipe as the field name and gives me error 2465. One of the fields that I am trying to reference is in a header. This is a patient system...

I already have a query that is the data source of this report. Can't I use the fields in the query (if they are checked to be visible) to make decisions on in the code. And then put the code in the ON_FORMAT event of the detail section of the report? Thanks.. Skyhighe

This one should be a drop dead no brainer... I must have mind lock... I can't seem to think this one through. I have a standard (I built it) query which provides records to a report. I have 2 possiblities for a Physician's name depending on the financial group that the patient belongs to. If...

Is there any way to run Access SQL outside of access like in an Oracle database. I have some fairly convoluted sql that needs to be debugged but the inner join/outer join verbage causes it to gag in any of the other databases I have tried... Thanks in advance

I need to have a query with a basic Where clause which before the DoCmd is executed to run the report I then supplement the where clause with additional information. I need to know 3 things... 1. Can a query have its Where clause supplemented with additional information 2. How do I get the...

I have a screen [switchboard] which supplies a call to a screen which takes the reporting facility and division from the user by them selecting radio buttons. I then want to build a "where clause" for the particular report that has been chosen from the switchboard and put the filter on...