Recent content by TippMan

Thank you VilaRestal! All your suggestions worked :) I just had to modify the field names, and I used these as the criteria for the ActiveStatus column: 1. Choose([Forms]![fdlgCo_Status]![Status],'1','23','4') Like '*' & [ActiveStatus] & '*' 2...

I have created a popup form which has an option group with 3 check boxes fo0r EmployeeStatus options: Active, Option Value=1; Recent Leaver=2, Former=3 The data I am querying is imported from a payroll program and has 4 status fields - 1=Current, 2=LeftThisYear, 3=LeftLastYear, 4=Former I...

Thanks again Uncle Gizmo, That sorted the problem - I will bear those reserved words in mind in future. My form is completed and I have learnt how to use "Insert Into”. However I will be back to this forum - it is a fantastic resource and I have a lot to learn! I attach the database so that...

I do not want to add the records to tblSales until I am sure that the data entry is correct and I do not want entries for depts with zero sales.That is why I want to use temporary values in tblDepts. I have tried to modify the “insert into” code kindly provided by Uncle Gizmo to add the data...

Thanks for all you help Uncle, I need to spend some time to work out how your code works. :) I fear I will have some more questions:o

The reason I am using tblDepts as the subform is that this is the only way I can see of automatically listing all the departments so that the user does not have to enter any department details, they appear automatically on the screen. I attach a file showing a copy of my form I created a query...

Thanks for your help, Uncle. I have now created an unbound form for Date, Reg and Total Reading with a subform in datasheet format based on the tblDepts. I added a field called tempValue to the tblDepts to temporarily hold the dept sales values. (This field will be cleared after the form is...

Sorry Umcle, There are 2 cash registers, So the register number is either 1 or 2 My question wasn't very clear, Is the "register" that you refer to an arbitrary number or is it an actual "cash register"? Today 10:05 PM My question wasn't very clear, Is the "register" that you refer to an...

I need to be able to later summarise the departmental totals by register.

I need to create a database to record daily departmental sales from the cash registers in a shop. I have 2 tables Sales and Depts. Sales = SaleId(autonumber), Date, Reg, Dept, Value. Depts = Dept, Vat I need to create a form to enter the data. I want the top part of the form to have Date, Reg...