S
singingsister
I am a complete Access newbie and am stuck!
I have an excel spreadsheet which is basically our order book. It shows all
orders placed on our companies and information like company information, what
date the factory say the order should be d espatched and what date the order
is actually despatched.
I have linked the excel sheet to my access database with no problems.
What I want to do is run two queries that I can run on an as and when basis
to show
1st query) orders due within a certain time period (ie 2 weeks from todays
date)
2nd query) orders that are late and have not been shipped.
I have, with help from a colleague managed do create a query for the orders
due within a certain time period, using BETWEEN [FROM] AND [TO] under the
"date the factory say the order will be despatched" and IS NULL under "actual
despatch date" (I want it to show orders that have NOT been despatched) On my
order book, I fill in a date under "actual despatch date" when I know the
order has been shipped.
Problem is, I keep getting a NUMERIC FIELD OVERFLOW. Sometimes I can get the
query to run once and then the second time I run it I get the error. Now I
know on my excel sheet, that in some cases there is a "-" under actual
despatch date but I am happy for access to show this as "-" and I can deal
with this as necessary.
For the 2nd query - I have used the criteria <DATE() under "date the factory
say the order will be despatched" and IS NULL under "actual despatch date" (I
want it to show orders that have NOT been despatched). The query runs fine
but for some reason it is showing ALL orders with an "date the factory say
the order will be despatched" regardless of whether it has a date on the
"actual despatch date". I only want it to show orders which DO NOT have a
date in the "actual despatch date" column.
Can someone please help me? I am tearing my hair out!!!
I have an excel spreadsheet which is basically our order book. It shows all
orders placed on our companies and information like company information, what
date the factory say the order should be d espatched and what date the order
is actually despatched.
I have linked the excel sheet to my access database with no problems.
What I want to do is run two queries that I can run on an as and when basis
to show
1st query) orders due within a certain time period (ie 2 weeks from todays
date)
2nd query) orders that are late and have not been shipped.
I have, with help from a colleague managed do create a query for the orders
due within a certain time period, using BETWEEN [FROM] AND [TO] under the
"date the factory say the order will be despatched" and IS NULL under "actual
despatch date" (I want it to show orders that have NOT been despatched) On my
order book, I fill in a date under "actual despatch date" when I know the
order has been shipped.
Problem is, I keep getting a NUMERIC FIELD OVERFLOW. Sometimes I can get the
query to run once and then the second time I run it I get the error. Now I
know on my excel sheet, that in some cases there is a "-" under actual
despatch date but I am happy for access to show this as "-" and I can deal
with this as necessary.
For the 2nd query - I have used the criteria <DATE() under "date the factory
say the order will be despatched" and IS NULL under "actual despatch date" (I
want it to show orders that have NOT been despatched). The query runs fine
but for some reason it is showing ALL orders with an "date the factory say
the order will be despatched" regardless of whether it has a date on the
"actual despatch date". I only want it to show orders which DO NOT have a
date in the "actual despatch date" column.
Can someone please help me? I am tearing my hair out!!!
