Search results

:confused: G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus. :confused:

:confused: I did as you said however I get an error message stating that: "You tried to execute a query that does not include a specifed expression 'Month([Startdate])=[Month]' as part of an aggregate function. If I remove the criteria the query result shows the number for each month, but if...

G'day all, I'm a novice to Access. I'm trying to setup an adhoc query, whereby a user can select all the records for a particular month. I've tried using ([month]) in the criteria row but I get an error message??? :confused: :confused:

Hi I guess this is another basic question. How do I get a date field within one of my forms to default to the current date? And when setting up a duration field should it be defined as a date/time field?

Cheers mate!!! You're a Champ!

Hi All, I'm a novice to Access and I need some help developing a form page where by users can input and record daily project activities. I have most of the form complete, however, i find that when a user accesses the page the previous record is sometimes showing. How do I setup my form page so...