Simple query date problem

[Justchris]

I have a table set up which uses date for primary key. That being said, each record is based on short date. Can i make a query that uses input from the user? I ask because i would like the user to input a date, then the query displays a sum of all dates previous to the inputed date.


Any help would be great
Thanks
Chris

 

[Brianwarnock]

You have another post related to this but I will let others more experienced than I comment about the suitability of using Date as a Primary key I think that wouldn't do it but don't know of any problems if you can gaurantee uniqueness.

To this question I would use a form for the user to input the date
frmdate and seldate for control say

Then your total query would sum on the required field where on the date field with < [forms]![frmdate]![seldate] in the criteria

You can place a command button on the form to run the query

Brian

 

[Justchris]

Thanks, and ya... sorry for the double post, the other post was more dedicated to a simple yes no relating to if i could even set a user input for a query but there both related.

Sorry
Chris

 

[Brianwarnock]

That's ok somebody may come back on your design question, they are related but not identical posts.

brian

 

[Justchris]

How can I set up a form that asks for an inputed date then using that inputed date it opens up a new form for entering totals based on the inputed date. If the date already exists I would like it to pull up that dates information in the form instead of 0's. Any help would be great..


Thanks
Chris
so close to figuring it out and so far to go till completed