Search results

Hello. I want to create a query that will return all records that were entered from today to 7 days ago. I have a DateEntered field on my table that stores the date information and I have been playing around with what I entered in the criteria there, but nothing seems to be working. I was...

Hello everyone. I am wanting to store the date the record was entered into the table. But I don't want the users to have to type this in; I thought that Access could grab the date from the system date. I am new to this and I looked at the Date function but I am thinking it will just always...

Hi. I have created a query that does a simple count of all the unique client records in the database. I would like to display the count on the main form. How would I go about doing this? Thanks for any help that can be provided.

Hello, is there any way I can have my single-parameter query bring up a lookup list of options from a table field rather than relying on the user to correctly type in the criteria? Then when this query runs I will know the user is picking one of the correct options from the lookup list. Thanks.

Hello. I have created a database to keep track of clients and their training requests. I have already created the tables and have some data entered. It is just now that when attempting to create a query with the two tables that I realized I have problems as I am getting a Type Mismatch error...