Search results

Yeah i played with a union query and i don't think it is what i'm looking for I'm pretty sure that the merger of a select query is what i need....

Well I still haven't figured this out so I guess i'm just gonna drop the idea for now. If you do have any ideas let me know otherwise.... Thanks for your help!

I know fresh eyes Oh my knowledge has absolutly expanded from when I started.

Oh I am so frustrated!!! I have officially tried everything that my limited knowledge allows.....

Query 2 is the one I have been working on. the form with the buttons is frmViewAvaliableReports

I know it needs a ton of work.... right now i'm still developing and testing and I haven't cleaned anything up so there a some unused queries and such... I have tried to keep it normalized but no promises. There are still some things I would like to put into the DB eventually but If I can get...

ok so since for testing purposes i'm only using dataview of the query at this point when I run the query I want to see all Listings for a monthe and a year that I enter. If there is a sale off one of those listings I want that sale information but the sale is during that same month and year. as...

Maybe I misunderstood. It seems to be date related yes. So you are suggesting using the filter in the command button to display the records I want right? but I need to be able to enter the month and year that I want. and If there are no sales I want just listings if there are sales I want both...

Ok thanks for the tips I will make the adjustments but this doesn't solve the problems I'm having with my query.

no problem here it is

the month and year a simply query parameters

I have attached a picture of the results that I get with the following SQL statement SELECT tblListings.ListingDte, tblOrderHeader.OrderDte, qryFinalProductIncomeExpenseCalculation.OrderID, tblInventory.Picture, tblListings.SKU, qryFinalProductIncomeExpenseCalculation.ProductTitle...

i just had a pop up form with command buttons to open each report that is all that is on that specific from is command buttons one for each form

this isn't for a form it is for a report

ok this might be progress ;-) I changed the where clause as follows WHERE DateSerial(Year([Enter Start Date mm/dd/yyyy/]), Month([Enter End Date mm/dd/yyyy])-1,1) And DateSerial(Year([Enter Start Date mm/dd/yyyy/]), Month([Enter End Date mm/dd/yyyy]),0) The problem i'm having with this is it...

oh i had an idea let me see if this works!

Ok so I changed my Where clause to your suggestion and I kept getting a missing operator error. So I added [ListingDte]= to the beginning of the statement after WHERE and i no longer get the missing operator message but it also returns no records. also I need to be able to enter the month and...

I have messed with using some other date functions and none have worked does anyone have any suggestions?

Ok I looked into the outer join option andwith a bit of editing it worked! my query in now showing all records but I have run into another issue the editing I had to do was removing the DatePart function from the query. Because I had to remove this I now have records showing that I don't want to...

I used the macro builder it does OnError then the RunCommand to SaveRecord some more error stuff then it opens a query to update a table changing the order status to paid then it closes the query next it opens another query that updates the stock levels then closes it again and finally it closes...