Search results

i have a date that is calculated from another date from the frequency. Thats value is not stored its calculated everytime. Now i need to run a query to find the events that fall in a range that would be covered in the calculated date. should i store that date, if so how do u store the...

its says undefined function "adddate" in expression. Jason

how do i run a query on a date range that is a calculated date that is not stored but calculated in the form. i have a field that calcs the next scheduled date and want a to run a query that shows the calculated dates that fall in that range. thanks Jason

is that the calc you use when querying, or is that for the field. on the same note, i already got the intervals to calculate how i want them, so i guess my definitive question is how to build a query that can look for the calculated dates that fall in a range of say a week or 2 weeks etc. thanks...

can anyone explain to me how to use this? i have a date and a frequency and i want to calculate the next event. I am refering to the example on mvps. Where do i put this code and howcan i store it so that i can use a query to find upcoming events. thanks i really need help on this one quick Jason

it bounced back to me, so ill pm you a link Ok real quick ill run you thru the steps to get where I mean. -find customer -by company name -double click “Test Company” -goto jobinfo tab -and there it lists the specific services for that comp (double click to view), now that’s a one shot deal...

ok i have one u can look at. how do you like me to send it, i dont wanna post it, it has company stuff in it etc.

um, im goin to have ot make a stripped version of it so u can get what i mean. im gonna try and see if i can break it down. Jason

i dont really understand when i run a query, where does it get the history from? if i dont store it somewhere how can i find a work order from last year. right now its just in a table for the current one. but if i make a change then the old info is gone. i think i just dont understand how that...

i have a table that holds all the customer info to make a work order. there are quite a few subforms that are datasheet associated to that particular record. when i make a work order, i want to save it some where else so that i can go back and look at the work orders like year later. how...

awesome. the data that i want to be in the query is all from the same table. the criteria for filtering is in two. does this still work the same way? all the main info is in the same table, but the status is in two different places. like the check box for if its a new lead is in the main...

i have a customer database and there are two types of sales leads. either its a new lead, or an exsisting customer with a new lead for an additional service. i have a main table that hold the basic info for both types. but, when its an exsisting customer, the info is in a different table that...

hey i figured it out some wierd different way, but thanks soo much tho Jason

Pat - ok right now i have a table called ZIPCodes. It has like 71000 entrys in it for every zip in the US. Now i wasnt sure what u ment by "fk", and i am not too sure how to make it look up tha values. I am really new at this so the more basic the answer the easier for me to understand...

actually i was looking for a working sample database. but thanks tho JAson

Actually i found a previous post from you that is exactly what i was looking for. Thanks for your previous information Jason

i have a last service date, and i want to use the frequency of the service to calculate the next service date and save it in a new field. the frequencys are in days, like 7,14,30,60,90,180,etc. And i ideally i would like to run a report that shows me what things are due within 1 week , 2...

im gonna give that a try, thanks. Jason

i have a list of phone numbers and there is a check box to say if its inactive. i would like to have it so that is always moves the inactive ones to the bottom(desending). any ideas? thanks jason

anyone have an example of how to layout the tables for a zip code autofill look up? i am trying to get this to work and in the ones i found in the search, they werent straight forward enough. If anyone has a method or example, that would be much appreciated. thanks jason