Search results for query: *

How would I put that condition into the query - bring the start date field into the query and have the tax rate populate based on the date ranges? Any ideas on the logic involved in that?

Hello, I have a functioning Access database that is used by a vendor for the input of the receipt information. From that I numerous queries running off of other queries in order to create the necessary reports. I have ran into a programming issue with this now. The tax rate for one of the...

Tony, Thanks so much for your help. That worked great! Hope you had a great Holiday! Thanks again! Melissa

All I did was enter the command in the Criteria Line in the design view of the Query: Like [Enter Location Name] That does make the Query Prompt me but it returns no results. If I remove that command and just use the date range then it works perfect and returns the data for all Locations in...

Have you tried making one query out of the three tables and linking them together. Only include in that query the data you need for your report. Then you can build one report off of a single query.

I am trying to set my query up so that it prompts for a location name and a date range when ran. The date range works great but when used in conjunction with: Like [Enter Location Name] it fails. It prompts for a location name but returns the query with no data and the date range is blanked...

Hello, Thanks for the tips. I was placing the dlookup command in the after update field. I used the expression builder and entered it there. Dim stCounty As String stCounty = Nz(DLookup("[countyID]","locations","location ID]='" & Form_ReceiptEntry.[County ID] &...

Thank you for your help. I entered the expression from this point on and entered it as an Expression Builder on the After Update command. Nz(DLookup("[countyID]","locations","location ID]='" & Form!ReceiptEntry.[County ID] & "'"),"") Did I...

Thank you for your help. I entered the expression from this point on and entered it as an Expression Builder. Nz(DLookup("[countyID]","locations","location ID]='" & Form!ReceiptEntry.[County ID] & "'"),"") Did I miss something because it is...

Hi there, I ran into a similar problem when I took a copy of a database and burned it to CD. I then tried to load it on another computer that did not have the same network access and got the same message that you got. Did you relocate the database to a new computer?

Hi, I have written the following expression to set a value in a field on a form based on the data in another filed: DLookUp("[countyID]","locations","[location ID] ='" & [Forms]![Receipt Entry]![County ID]) I am trying to have a field self populate based on...

Thanks a bunch for the help. This is the command that I wrote: =DLookUp("countyID","locations","location ID ='" & [Location ID] & "'") It is returning an error to me. It is a form that is linked to query. The [Location ID] is the field that is...

I am creating a database for a vendor and I am trying to get one field on a form to lookup a value from a table. The other fields already run on macros and are just used to populate dollar amounts. I need the county ID to populate automatically based on the Vendor name. Does anyone know the...

I am trying to set up an Access form so that the item selected in the combo box populates the rest of the fields on that form. I want to use it as a lookup box so that when someone selects a Company, the company information will populate in the rest of the fields. Any ideas?

I am trying to set up an Access form so that the item selected in the combo box populates the rest of the fields on that form. I want to use it as a lookup box so that when someone selects a Company, the company information will populate in the rest of the fields. Any ideas?