Problems with record compiling

[fixious123]

Hello. Im trying to put together a shot record database and currently I have all the shots and based on a taken date using the DataAdd feature tells me the due date. I want to generate a report based on that due date but don't have an idea on where to start. I would like the user to know who is coming due so he/she can get in contact to inform patient that he needs to get his arm stuck. Any other ideas or better way of doing things is greatly appreciated. Thanks for you assistance.

 

[spacepro]

Create a query with the fields you require in the report then in the design grid of the query enter the following:

DueDate: Put here the calculation for the due date

This basically creates a column in the query which calculates the
due dates.

You can then create a report based on the query.

Hope this helps

Andy

 

[fixious123]

Report problems

Thanks Andy, I'll give it a shot.

 

[fixious123]

Query

Where does the formula for the Due date get entered?

 

[spacepro]

Look at the image.

Regards

Andy

 

[fixious123]

Thank you. Problem is I can pull the due dat into the query table but it doesn't show up on the report. Do you have any ideas that would make this database run smoother or is this good enough.?

Thanks again

 

[spacepro]

You should be able to puul the data into the report.

Try with the report wizard

If not post the db and I will have a look.

Andy

 

[fixious123]

Good to go thanks Andy. But another ? For instance I have a couple of shots that are a 6 shot series and a booster every year or two after. Whats the best way to generate a report to show which shot they took and the correct due date reflected in the report. What I basically want to do (at the end if its in sight) is have a report with every due date for all shots coming up and see who is coming up very shortly so they can be contacted. Thanks in advance for all your help.

 

[spacepro]

Post a db and a little explanation and I am sure I can have a look and give you some ideas.

HTH

Andy

 

[fixious123]

Shot record Database

Any ideas please don't hesitate. Thanks again for your time

 

[spacepro]

Haven't got time at the moment but I had a look and this is what you can do to achieve your goal:

Firstly don't have field names with spaces , change them to say TetanusDiptheriaTaken and not Tetnaus Diptheria Taken.

This will only cause you problems later.

Right Create a query with the fields you want in the report and copy the dateAdd strings for each shot from your fields in the form and add them into the query as follows:

TetanusDiptheriaDueDate : DateAdd( Your string goes here)

Then create a form with all the jabs on and two textboxes for each shot(these will be Fields for Dates - Unbound).

In the criteria section of the query you can enter the following:

Between Forms!YourFormName.yourtextboxname And Forms!YourFormName.your2ndtextboxname.

Do this for each Due Date in the Query.

Create a report based on the query and then you can run the report off a command button on the form with the between dates which have been entered by the user.

I hope this is clear.

Any problems give me a shout.

Andy

 

[fixious123]

What exactly does this do for me, Im running into some trouble with a combo box right now as posted earlier. Dealing with one shot but its got different types of this once shot and I want to select it and have dateadd calculate a due date based on the selection in the combo box.

 

[spacepro]

Basically the query generated calculates all due dates for all records in youo filtr main table, then the form passes between dates to filter the query for results within the date range.

Do a search for filter reports if you have any problems.

Andy