Recent content by Burnsie

thats got it, thanks

The data type is "number", field type is "long Integer" and decimal places set to 2 :confused:

Hello. I have a table that is displayed as a sub form of a main form (ie main form is cleint details, the subform are the results from a medical test) Anyhow, some of the data (medical tests) in this table requires a number to be recorded with 2 decimal places. This has been set as such in...

sorted it...it was simple (I probably didn’t explain it properly) I simply added a query (with a parameter of "What Staff number") as the source to my existing report like this...

sorry for the delay...been out of the office for a week. So, what i want is for me to be able to creat a report for each person, that they can take away with them. I will contain all their detials/results from the session. In the old database, I had it set up that when i opened the report, i...

errrrrr???? :confused:

no, its a report ive completed, which is formatted and strcuted and look nice :D so, how do you use a query as a source for the report (sorry for being stupid)

I have done, but if i open the form, i need it to only display the person sitting in front of me. At the moment it displays the detials of the first person I saw (cleint number 1).

oooo, I’ve progressed. In fact, I’ve nearly finished. Each person that gets "tested" will get a report with all their own test data on. I’ve made the report, but want to filter it, so all I do is click on the report and enter in parameter (employee number) and the report pops up. I’ve made...

right then... all i need to do now is work out how to produce a form based on Staffnumber.... ie click on reports and search for the number, that brings up the clients own report or their test results??

booming! right...lets get this done!

[/FONT][/COLOR] Yep. Just need to work out how to make the report do what I want...for some reason, it keeps putting headings in a header so its all in table format, rather than allowing me to move any data set where id like it to go :banghead:

so far so good, i think. (p.s. thanks for your help so far).

Really stuggling – novice building a database. Hello. I’ve posted a few times in various forums, but I feel I really need to go back to the start with my database here. I am rebuilding (from scratch) a database where you can track an employees’ health measures. These include things such as...

Don’t worry; I may still require your help.... So, I now how two forms, as mentioned above, with a relationship between the unique "staff number" in the "Personal details" table and the "staff number" in the "testing" table. I have a main form with Personal details, with a testing subform...