Search results

Hello everybody, We've all seen this error before and normally when I come across it I can see where the problem lies and I can fix it. This time however I can't and I'm starting to get a little bit, shall we say, annoyed :banghead: I am running a very simple query that divides profit over...

There's actually more like 6 queries but same theory still applies. I understand what you are saying but there is no 'earlier' use of a field called Stock. In fact the actual field is called TQUANTITY and I simply rename it as stock in the final query. I can however tell you that there are...

But why does it not do the same on the other 2 fields that I brought into the query?

Hello, Long time no post...... Right, I have a question. Sometimes when pulling information from a table using a design query we need to rename those unhelpful field names into something more descriptive. To do this we simply type our desired column header name before the actual column header...

That's it - you've done it! Thanks pr2

Voila SELECT [Low Margin Transactions].Day1, [Low Margin Transactions].PrevDay, [Low Margin Transactions].[Day(D&T)] AS [Invoice Date], [Low Margin Transactions].[Invoice Number], [Low Margin Transactions].Custcode, [Low Margin Transactions].Name, [Low Margin Transactions].BDM, [Low Margin...

Ok, To do this manually on a Monday I could type into the query criteria the following; Date()-1 OR Date()-2 OR Date()-3 This would fetch the low margin sales data for the Sunday, Saturday and Friday. For Tuesday to Friday I could simply type in Date()-1. To explain, we do process sales on a...

Day(D&T) is 25/07/2012 (for example) in Date&Time format. If I change the code to the Following (removing the ref to the table and field) it actually works; IIf(Weekday(Date())=5,Date()-3,Date()-1) In this case it returns data from Monday - which is correct. It falls over again though when I...

pr2, Still no result...... The query returns yesterday's data where the statement is false but not when it is true. Do you have any more ideas? It doesn't like it when the weekday is actually today (5 being Thursday)

Thanks pr2, I copied your code into the query, changing the day to 5 and it didn't return any records......? The reason that I don't group the 3 days is because I list the sales transactions down to invoice number and date detail therefore I'm happy, or rather need to keep all 3 days separate.

Hello, I have found threads on similar issues but still cannot find a solution to my problem so here goes; I have a query called Low Margin Transactions, that I guess speaks for itself. I have a query based on this which selects the previous day's figures where the margin is below 8%. However...

Hello. I am thenoisydrum and I visit your forums often in order to find solutions to every day Access problems. What a great place to come and visit! I have finally registered an account because I need to ask a question and I'm hoping that you guys will be able to help me..... All the best Drum