Search results

So if I do this Between[Beginning Date:] And [Ending Date:] I should get prompted once?

Excuse me don't want to prompted sixteen times

I have defintely written queries where I have done Between[Beginning Date] And [Ending Date] but in this case never for multiple date fields. I do want to get prompted sixteen times when I need to enter it only once.

I built this db for our HR department. When I met with them about the reports one of the ones they wanted was based off the 8 Licensure/Certification fields and the date fields associated with them. They need one report that is going to list the Licensure/Certification and the expiration date...

Not intentionally. Which ones? Thanks.

I built a form in Access 2007 today and when I look at in Form view part of the Form is hidden so you cannot see on the screen. If you use the scroll bar on the right you can see the rest of it. I don't remember this issuing occurring in older versions of access.

Thanks will try

In the database I am working on in a college course for a project with we have many tables like Employees,Products, Sales, and Sale Line Item. One of the requirements was to create a form that had the Sale information(which I did lookups to other table fields to allow them to populate the...

But I want to calcuate the total profit margin percentage off the totals for each field not one by one. I guess the one by one statement is a little vague

one by one?

I tried this in an unbound text box but it keeps giving me a missing ) =(((Sum([ProdUnitPrice]))-(Sum([ProdUnitCost])))/Sum([ProdUnitPrice]) Basically (total UnitPrice- total Unit cost) /Total Unit Price

Sorry. She will need to be able to access the database regularly as we need to build reports to capture the comment box responses.

Ok she has a form which may be a better option. I want to do the following things. On startup I know I can make the form appear. I want it to go to a new record and not allow the user to see other records in the database on the form. I do not want the database main window to appear so if they...

A co-worker built a data access page as part of her database. When she tries to view it in Access it brings up the window saying data provider might be unsafe. the html file is not saved to a web server just her network folder. Also I tried to open the Data Acess Page html seperately by...

Thanks That solved my issue. Seems to work both ways now.

Code Here it is: PARAMETERS [Type Name or hit ok to skip and run by Employee Number:] Text ( 255 ), [Employee Number:] Text ( 255 ); SELECT [CEAP Employees and Classes].Name, Sum([CEAP Employees and Classes].[Amount of Check]) AS [Total Amount] FROM [CEAP Employees and Classes] WHERE ((([CEAP...

I set up a query originally to run by entering a employee name and a date range. I recently added another parameter to run it by employee id. I put that on the or line. Problem is that runs the query by the id field itself. I need to have it so I run it either: ID and date range Name and date...

Example Hi Banana, Do you have an example of how to implement this from beginning to end?Would help expedite the development process. Also its a date range so would I not need two textboxes for that?

I did that I did that and saved the query. Ran it and it still did what I described. Went back in the query and it had reorder itself with the name,date range, and the number in that order. I am thinking it has something to do with that the number is on the "or" line.

I built a query that in turn is used in a report. The users of the database would like the option to run the report either by name or employee number along with a date range. So I added the field for Employee number to the query using Where in the total row and placing [number:] in the or row...