Jump to content
Posted 21 June 2005 - 06:00 PM
Posted 21 June 2005 - 08:47 PM
Edited by tos226, 21 June 2005 - 08:49 PM.
Posted 21 June 2005 - 08:53 PM
You may want to rethink this one. Some primary key is used now or will be in the furure as a unique ID of the customer. A cleanup of the primary key might be in order. But that's a whole other story.
Luckily we had a back up and were able to restore it (except that now the primary key numbers are wayyyy off but we really don't use that anyway).
Edited by tos226, 22 June 2005 - 03:05 PM.
Posted 23 June 2005 - 10:25 AM
Thank you so much for your response.
In the query pane, under the fields is a Criteria row.
Look in HELP for Criteria.
I'll try to give you some pseudo-syntax.
What you need is to write something to the effect fieldName>=Today()-180 (roughly 180 days), the syntax might be Now()-180 (or is that in Excel?). Or you can fix the date and say >= '1/1/2005' (again, look in help for exact syntax), though I would not recommend ever using a constant or every couple months you'll have to edit the query to be current.
Posted 23 June 2005 - 12:08 PM
I am assuming you reached this point, I have to assume something or can't answer
1. In the query Criteria row, it's not the double-click but right click which takes you to expression builder (select Build initially, zoom to look it over).
Edited by tos226, 23 June 2005 - 12:47 PM.
0 members, 0 guests, 0 anonymous users