Search results

My requirement is: In the form, find a record in table A by SSN, display several fields on the form with data from table A. Have several other fields on the form that data is then keyed into. Add a new record to table B with all the fields from the form. Can this be done? Can there be more...

I have a text box in my page header where I print the PHASE of the data I'm working on. PHASE is in the detail records that I'm summing. PHASE is a text field in the table. I sort, group and page break by PHASE in the report. When I do, the correct PHASE prints on the page header. The problem...

adz2013, Scratch my last question, I found that if there weren't any PDI's the value was null, i changed it to 0 and now all is working well. Thank you very much for your help. Tom

adz2013, Thanks for the tip, making progress here. Still 1 problem though. I tried both of your techniques and the results are the same....if i have at least 1 person who took PDI, then I get the proper total for both columns. But if no one took PDI, the sum for PDI is blank (which is...

adz2013, Thanks for the tip, making progress here. Still 1 problem though. I tried both of your techniques and the results are the same....if i have at least 1 person who took PDI, then I get the proper total for both columns. But if no one took PDI, the sum for PDI is blank (which is...

I'm trying to show how many people have taken 1 of two courses. If the person has taken "PDI" it has a 1 in the PDI column. If the person has talken "LDRN" it has a 1 in that column on the report. I need a caluculation that shows how many have taken either "PDI" OR "LDRN". So if 3 people in...

In case anyone else runs into this problem, I have resolved it. I searched the MS Knowledge Base and found a similiar problem. I applied patches SR-1 & SR-2 as recommended to the base Access97 application and the problem was rectified. Tom

I have tried the compact & repair to no effect, rebooting and closing all other aps to no effect and there is not an embedded background. I also increased my swap file from 267meg to 500 meg without effect. Interestingly, if I OPEN it (not convert) in Access2000, it works fine. Unfortunately...

I added a control button on a form in Access97 to printout the current record that is being displayed. When I click the button, the record does print, however I then receive the message " There isn't enough free memory to update the display. Close unneeded programs and try again." I don't...

My query asks which birth month to report on. The user can key in 1 thru 12 or an * for all months. On the associated report, I use the birth month field to display what the user keyed in. When a month is keyed, it displays it properly, but when * is keyed to run for all months, it is...

Thanks to both of you. I was unaware of the SQL View, that was a winner. Thanks again. Tom

I have a query going against a Medical Survey table. I need to show anyone who is past due on any of 10 different date fields. My problem is the criteria selection box only has 9 lines for 'OR' selctions. Is there any way I can include the 10th field? Thanks for your help. Tom

I went to the databases where it was not running and I did what you said....IT WORKED!!!..You're awesome...Thanks so very much. I unchecked the following: Microsoft Jet SQL Help Topics. Why was this impacting my query? Again, thanks so much, I was pulling my hair out trying to figure this...

Actually, it's not machine related. On my machine, I open the Master DB and run the query and it doesn't work. When I open the one called DR2000, which is linked to Master, it does run. When I open the one called Donna2000 (which is also linked to the Master) it does not run.

I am working on a database that has a Master database with 3 other databases, all with the same tables, linked to the Master. I was told this was done to combat contention problems. My problem is that on two of the linked databases, a query using the Date function is working (>Date()-880) yet...