Recent content by sumhungl0

ok i need to figure this one out for two projects. i need to get a difference between 2 records in the same column. how do i do this?

i got the answer..... thanks answer is here http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1541447

anybody know how to change inches to feet and inches for my report? if i use inches/12 it gets me a decimal. so then how do i convert that to inches, or tenths to twelfths?

hope i got this upload right. upload too large... but here it is

ok that doesnt help too much.... i been working on this report for 3 days now and pretty much all of today(long hours). i have no idea if im explainin myself correctly but im doin my best. im gonna try this again. this is for an above ground fuel tank that i need to track or log, usage...

i dont know what OpenArgs or OpenReport commands are.

gonna have to speak english. i dont understand access too much yet. thats kinda the point of this project is that i can learn better by doing. if you could tell me how to do what you are talking about i would appreciate it very much.

first ill explain my query to avoid misunderstanding. i set a query to get weekly results for this report im working on. the query does this by Between Date() And Date()-7 now i need to know how to get the date range to show in my report. i have a box that has start date and end date but i...

i got it thank you very much for all the help. heres what my problem was.... my table had the date format as text, so i changed it to medium date format and put my query back to Between Date() And Date()-7 and everything works great. thanks again everybody.. :) i feel like suck an idiot..

i only put that format for the input form, so does that mean the table doesnt use it as just a date?

its in this format... dd-mmm-yy or 01-Nov-07

just tried this with no results..... <=Date()-3 and >=Date()-3

im using 03 and i have changed the number from a little to alot and i still cant get any results. i know that the criteria would find the range of records i have, about a months worth.

im tryin to get this query to get data from current weeks inputs. ive googled and tried everything with no luck so far. so here i am. can someone tell me what im doing wrong? keep in mind i dont know what im doing..... heres what i put for criteria under my date column. Between Date() And...