Search results for query: *

i don't doubt that you "would have avoided the design error to begin with" and you are probably 100 times better with databases than i'll ever be, but i've tried my best and taught myself hence the "poor design" that you refer to. I'm a very busy person hence why as you put it, i'm not "too...

the week number field is used in various other tables. currently the week number is set as the primary key within this table. we input employees working hours into this database, therefore these are done weekly. within this table hours and employee ids are input against a specific week number...

redesign my whole database? surely not?

My database is well and truly set up and has been functioning for almost a year. however, i have recently noticed i made an error in my table creation as i forgot to include a year field. i have a tblWeeksDates which includes the week numbers for this year 1 - 52 and the start date of each...

Can you archive data within your database? I have data for the year 2006, and i wanted to start a fresh year 2007. is it possible to archive my previous data - i still need this data for reports etc, but it would be easier if it wasn't held within my forms. many thanks

I am aware that was an example, and have used my own field names. which are WeekNo and SCCash. I have also tried this method previously, although it doesn't want to return the correct results.

I have tried this however it returns #Name? in the field i am unsure of what else to try or why this isnt working.

any help on this would be much appreciated?

it is not returning any value just #Name? i will try editing it through dataview and see what results that returns thanks

data types are both currency. field is called Wage Rate in tblEmployees and tblHours (tblHours is the table the HoursForm is based on) the HoursForm also opens using a parameter query asking for the week no. do you think this is why i'm having a problem should the dlookup be in the query...

i have managed to remove that problem, and my code now stands like this: Wage Rate: DLookUp("[Wage Rate]","tblEmployees","[EmpId] =" &[HoursForm].[EmpId]) the only problem now is that within the wage rate field on the form, it now says : #Name? any ideas?

WageRate: DLookUp([Wage Rate],"tblEmployees","[EmpId]=" & HoursForm.EmpId) This now seems to bring up an input box which says, when i try to open the query. hoursform.empid: then it asks for my week no. - this is set up to do so anyway. i have tried different variations including brackets...

thanks, in my query i now have Wage Rate: DLookUp("Wage Rate","tblEmployees","[EmpId]=" & [EmpId]) i can't spot whats wrong with this but it is returning #Error in the field of the form. any ideas? thanks

that sounds like what i want to do but how do i do it? i have set up my form from a very basic table lay out. my SCCash field - do I use the control source to make it look at the tblHours SCCash field? I'm a bit confused. thanks

I have a value stored in one table that i wish to transfer to another form I have tblEmployees this stores the employee name, wage rate etc. I have tblHours this is used each week to input employee wages - the empployee id is entered, the hours worked, the week number etc. i want tblHours to...

My query now looks like this: SELECT * FROM tblHours WHERE Cash <> 0 OR [Petrol Receipts] <> 0 OR [Other Receipts] <> 0 OR Miscellaneous <> 0 (((tblHours.[Week No])=[Enter Week No:])); The report brings up an error message saying there is an invalid usage of "," "!" sorry this is really not...

sorry i'm unclear. I want the report to print a list of employees who are owed for Cash, Petrol Receipts, Other Receipts and Miscellaneous. i do not want the report to show any employee with £0.00 in those fields. my query is set up as follows: Week No EmpId Cash PetrolReceipts...

I have a query and i want the report to print out details of employee cash required that week. These have been input in tblHours. However i have set the query up with 'True' in the criteria for each of the Cash fields. so as not to print off all employees including those without cash. these...

I have a database which works fine for inputting weekly wages and calculating gross and nett totals etc. each week a certain amount of cash is paid to workers as part of their wage. we have a cash distribution form which is currently on microsoft excel, which means it is completed out of the...

thanks for the help guys, its working great now