Search results

I did try this and it worked the first time and brings the form up when you open the query. However, on all subsequent times it just brings up a parameter query.... Any ideas about this? Thanks!

I did what all the posters advised and normalised the process instead. Created two tables. The first table had the following headings: EMPLOYEE -EMPLOYEE ID David -DA Sheila -SH Rachel -RA Eric...

I would like to do this - just not sure how exactly (?!)

Thanks for any help :-)

I did try that previously but it didn't seem to work. I have tried removing them now so that it looks like this: PARAMETERS [Enter Date] DateTime; SELECT * FROM [Reminder and Ongoing Events Table] WHERE Popup Date 1=[Enter Date] or Popup Date 2=[Enter Date] or Popup Date 3=[Enter Date] or...

Any ideas anyone!?

OK, so I added this parameter. I also filled out this query using the actual headings on my table and the correct table name. The SQL view looks like this: PARAMETERS [Enter Date] DateTime; SELECT * FROM [Reminder and Ongoing Events Table] WHERE 'Popup Date 1=[Enter Date] or Popup Date...

OK. thanks very much! However, when I tried adding the above query in SQL view it did not seemed to work. It pulled up all the records and does not prompt the user for a date..... Am I doing something really obviously wrong?! Sorry! Elspeth

I am currently building a booking and invoicing database for the small business where I work. One aspect of this database allows you to enter an employee name and schedule days off via a form I have already built. To access this information I would like a parameter query where you can enter a...