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...

Thank you very much everyone. It worked. :)

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, thanks for your help. :) I have decided to do the count in a query and display it on the form. But I keep getting the #Name? error. I think my syntax is wrong. I have put [TotalClientCount]![TotalCount] in the Control Source box. TotalClientCount is the name of the query and...

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.

Great! Thank you for your answer. :)

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.

Sorry! Double post.

Thank you so much Keith! It worked. :) I appreciate it greatly!

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...