None working SQL - help please.

[Jane]

Hi everyone

I am going mad with this (sorry just had to put that in to show you my state
of mind). I have been working on this stupid thing now for 3 days.

I have a really simple Count of the orders for this year. It has always
worked. How could it not ???

Example

SELECT Count(IIf((Year([OrderDate])=Year(Date()) And
[OrderDate]<=Date()),[OrderDate])) AS OrdersThisYear
FROM SomeTable;

I have copied the database on to a new machine and "everything" works fine,
except for this. I am getting a lower figure on this new machine than I do
on the old machine.

I have checked "everything". Re-written to sql. Checked the field name.
Checked the table name. Checked the spelling. Even sat and looked at it for
hours just to see if that would help. It didn't.

Please help to save my marriage as my husband is bored with me bringing this
home from work and trying on my home laptop (where it works just fine).

I have always been impressed by the high quality of the technical advice on
this site and I have never placed a question here previously but now Access
Gurus I need you help.

Thank you for your time

 

[Wayne-I-M]

Hi Jane

I always try the simple “stuff†1st – ya never know

I am getting a lower figure on this new machine than I do
on the old machine.

Have you check the Time/Date on computer that you place copy on?

If date on the new computer is previously to on your old one, will show less
Orders if you had orders between the dates.

Just a thought


--
Wayne
Manchester, England.

Hi everyone

I am going mad with this (sorry just had to put that in to show you my state
of mind). I have been working on this stupid thing now for 3 days.

I have a really simple Count of the orders for this year. It has always
worked. How could it not ???

Example

SELECT Count(IIf((Year([OrderDate])=Year(Date()) And
[OrderDate]<=Date()),[OrderDate])) AS OrdersThisYear
FROM SomeTable;

I have copied the database on to a new machine and "everything" works fine,
except for this. I am getting a lower figure on this new machine than I do
on the old machine.

I have checked "everything". Re-written to sql. Checked the field name.
Checked the table name. Checked the spelling. Even sat and looked at it for
hours just to see if that would help. It didn't.

Please help to save my marriage as my husband is bored with me bringing this
home from work and trying on my home laptop (where it works just fine).

I have always been impressed by the high quality of the technical advice on
this site and I have never placed a question here previously but now Access
Gurus I need you help.

Thank you for your time

 

[Jane]

OMG That fixed it.

I wasn’t going to answer you as I now feel so stupid (can you believe I get
paid for this), but of course I have to.

Thank you so much

Of course I will explain to everyone that it was highly technical problem
that, using my skill and years of experience, I managed to fix. LOL.

I love this forum

A big thanks to all the MVP's who have helped me over the years without ever
knowing it.

Hi Jane

I always try the simple “stuff†1st – ya never know

I am getting a lower figure on this new machine than I do
on the old machine.

Have you check the Time/Date on computer that you place copy on?

If date on the new computer is previously to on your old one, will show less
Orders if you had orders between the dates.

Just a thought


--
Wayne
Manchester, England.

Hi everyone

I am going mad with this (sorry just had to put that in to show you my state
of mind). I have been working on this stupid thing now for 3 days.

I have a really simple Count of the orders for this year. It has always
worked. How could it not ???

Example

SELECT Count(IIf((Year([OrderDate])=Year(Date()) And
[OrderDate]<=Date()),[OrderDate])) AS OrdersThisYear
FROM SomeTable;

I have copied the database on to a new machine and "everything" works fine,
except for this. I am getting a lower figure on this new machine than I do
on the old machine.

I have checked "everything". Re-written to sql. Checked the field name.
Checked the table name. Checked the spelling. Even sat and looked at it for
hours just to see if that would help. It didn't.

Please help to save my marriage as my husband is bored with me bringing this
home from work and trying on my home laptop (where it works just fine).

I have always been impressed by the high quality of the technical advice on
this site and I have never placed a question here previously but now Access
Gurus I need you help.

Thank you for your time