Search results

Thank you for your time Mile-O-Phile. Do anyone else have any sugguestions on how I can obtain my result? Any help would be great. Thanks Chris ________ colorado dispensaries

Hey, I have a query named "qrymondayavgcalls" which includes just two fields, "Date" and "CallsOffered". So when you run this query you will get these 5 numbers in the calls offered field 578 209 287 411 420 Total 1905 So What I want to include is another expression to Sum those 5 fields and...

HI there, I have a query created which performs some calcs which I want to output on a form but when I am going through the form wizard the expression field that I need to show on the form is not there to pick from. Any ideas or how I can work around this, I have attached a view of the query...

Hey neileg, The ID is not a Memo or OLE. I have the query working now thanks. Chris ________ buy vaporizer

Hey, I was wondering if anyone can help me get started on creating calculations from I table. I would assume you would create them in a query, but I am really not sure. For example: In tblmain, I have two fields HoursWorked and HourlyWage. In tblpay I want to take the HoursWorked and HourlyWage...

Hey, Just wondering if anyone can explain to me how I can write code, to MOVE a record from one table(tblmain) and put that into another table(tbltemp). Thanks Chris ________ volcano classic

Neil, Here is the message I get when I try to select the union query in the wizard "There are no fields in this table or query that are valid for a join. Select a table or query that contains at least one field that does not have the Memo or OLE data type." thanks Chris ________ gaston chevrolet

Hi, I have the union query created but when I go throught the "Find Unmatch query wizard" it do not let me add the union I created. Any idea? Chris ________ toyota tf109

I am running a query with multiple criteria set on 3 different fields in the query. The first field which is named Valid(I only want the No, so the criteria set on this field is "N"). The second field is State(When I run the query I only want Flordia, so I got criteria set as Like "Flordia" for...

Hi there, I have a quick question about a query. I am using a table based on my query and I want to pull all entries from the "Country" field to only select "Canada". In my design view I specify "Country" and from here I am not quite sure how to proceed? Any Suguestions! ________ mercedes-benz...